﻿<%@ Page Title="List Award" Language="C#" MasterPageFile="~/Manager/Manager.master" AutoEventWireup="true" CodeFile="ListAward.aspx.cs" Inherits="Manager_ListAward" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v11.2, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx1" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v11.2.Export, Version=11.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView.Export" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style3
        {
            width: 41px;
        }
        .style4
        {
            width: 35px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <table style="width:100%;">
        <tr>
            <td class="style3">
                                <dx1:ASPxButton ID="btExportPDF" runat="server" 
                                    CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
                                    onclick="btExportPDF_Click" 
                                    SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" Text="Export to PDF" 
                                    Width="129px">
                                </dx1:ASPxButton>
                            </td>
            <td class="style4">
                                <dx1:ASPxButton ID="btExportXLS" runat="server" 
                                    CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
                                    onclick="btExportXLS_Click" 
                                    SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" Text="Export to XLS" 
                                    Width="128px">
                                </dx1:ASPxButton>
                            </td>
            <td>
                                <dx1:ASPxButton ID="btExportXLSX" runat="server" 
                                    CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
                                    onclick="btExportXLSX_Click" 
                                    SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css" 
                                    Text="Export to XLSX" Width="128px">
                                </dx1:ASPxButton>
                            </td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style3">
                &nbsp;</td>
            <td class="style4">
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
    <dx:ASPxGridView ID="gvwreportaward" runat="server" AutoGenerateColumns="False" 
        CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" 
        DataSourceID="Award" KeyFieldName="StudentID">
        <Columns>
            <dx:GridViewCommandColumn ShowSelectCheckbox="True" VisibleIndex="0">
                <ClearFilterButton Visible="True">
                </ClearFilterButton>
            </dx:GridViewCommandColumn>
            <dx:GridViewDataTextColumn FieldName="StudentID" ReadOnly="True" 
                VisibleIndex="1">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Firstname" VisibleIndex="2">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Lastname" VisibleIndex="3">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Award_Name" VisibleIndex="4">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Awrad_Details" VisibleIndex="5">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataDateColumn FieldName="Awrad_Date" VisibleIndex="6">
            </dx:GridViewDataDateColumn>
        </Columns>
        <Settings ShowFilterRow="True" ShowTitlePanel="True" />
        <SettingsText Title="List Award" />
        <Images SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css">
            <LoadingPanelOnStatusBar Url="~/App_Themes/DevEx/GridView/StatusBarLoading.gif">
            </LoadingPanelOnStatusBar>
            <LoadingPanel Url="~/App_Themes/DevEx/GridView/Loading.gif">
            </LoadingPanel>
        </Images>
        <ImagesFilterControl>
            <LoadingPanel Url="~/App_Themes/DevEx/GridView/Loading.gif">
            </LoadingPanel>
        </ImagesFilterControl>
        <Styles CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx">
            <Header ImageSpacing="5px" SortingImageSpacing="5px">
            </Header>
            <LoadingPanel ImageSpacing="5px">
            </LoadingPanel>
        </Styles>
        <StylesEditors ButtonEditCellSpacing="0">
            <ProgressBar Height="21px">
            </ProgressBar>
        </StylesEditors>
    </dx:ASPxGridView>
    <dx:ASPxGridViewExporter ID="gridAward" runat="server">
    </dx:ASPxGridViewExporter>
    <asp:SqlDataSource ID="Award" runat="server" 
        ConnectionString="<%$ ConnectionStrings:Institte_of_Fine_ArtsConnectionString %>" SelectCommand="SELECT     Student.StudentID, Student.Firstname, Student.Lastname, Award.Award_Name, Award.Awrad_Details, Award_Details.Awrad_Date
FROM         Award INNER JOIN
                      Award_Details ON Award.AwardID = Award_Details.AwardID INNER JOIN
                      Posting ON Award_Details.PostingID = Posting.PostingID INNER JOIN
                      Student ON Posting.StudentID = Student.StudentID">
    </asp:SqlDataSource>
    <br />
</asp:Content>

